<?php
/**
 * Fichier contenant la creation de la base
 * @author Nicolas Genevaux
 * (c)nige 2008
 */
	$OBJET = 'CREATE TABLE `objet` (`idobjet` INT NOT NULL AUTO_INCREMENT, `idparentobjet` INT NOT NULL, `nom` VARCHAR(256) NOT NULL, PRIMARY KEY (`idobjet`)) ENGINE = MyISAM';
	$LIEU = 'CREATE TABLE `lieu` (`idlieu` INT NOT NULL AUTO_INCREMENT,`idville` INT NOT NULL, `nom` VARCHAR(1024) NOT NULL, `logo` VARCHAR(1024) NOT NULL, PRIMARY KEY (`idlieu`)) ENGINE = MyISAM';
	$DEPENSE = 'CREATE TABLE `depense` (`iddepense` INT NOT NULL AUTO_INCREMENT, `idobjet` INT NOT NULL, `idlieu` INT NOT NULL, `montant` VARCHAR(1024) NOT NULL, `datedepense` VARCHAR(8) NOT NULL, `heuredepense` VARCHAR(2) NOT NULL, `description` VARCHAR(1024) NOT NULL, `encaisse` VARCHAR(1) NOT NULL, PRIMARY KEY (`iddepense`)) ENGINE = MyISAM';
	$DEPENSE = 'CREATE TABLE `compte` (`idcompte` INT NOT NULL AUTO_INCREMENT, `libelle` VARCHAR(1024) NOT NULL, `description` VARCHAR(1024) NOT NULL, PRIMARY KEY (`idcompte`)) ENGINE = MyISAM';
	$VILLE = 'CREATE TABLE `ville` (`idville` INT NOT NULL AUTO_INCREMENT,`nom` VARCHAR( 1024 ) NOT NULL ,PRIMARY KEY ( `idville` )) ENGINE = MYISAM';
	$VILLE_INSERT = 'INSERT INTO ville (nom) VALUES ("Aucune")';
?>
